Menu Planner

The Menu Planner is a tool to help you plan the profitability of both existing and new menus you provide. You can group recipes into one seasonal menu and also import your sales mix to see how each recipe contributes to your total cost of sales. You can then export reports to show the financial implications of any decision before you change your menu.

The tool enables you to add new recipes and change existing ones without affecting live data. You can even add ‘temporary’ ingredients before you have full supplier details set up on the system so you can still use them to work out the cost of a dish.

To access the Menu Planner, you need to have access to Stock Admin, the ‘Menus’ page can be found on the left-hand side just below the ‘Recipes’ page.

Creating a New Menu

  1. Select 'Add New Menu'

  2. Change the name of the menu by selecting the pencil to edit the name.

  3. Select the 'Visibility' of the menu. Sharing the menu will allow it to be visible to other users. Selecting “Just me” will keep the menu visible only to yourself.

  4. Select 'Add New Course'

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-11-21_09-51-23.png

Creating a Course

This is where you can add existing recipes in your database to a menu.

  1. Once you have selected a new course, enter a course name

  2. Select the recipe category that the recipes belong to, i.e. ‘Starters’ or ‘Sides and Smalls’

  3. Select the recipes from the left and move them to right to make the selection

  4. Save your changes

    You can look for recipes in all categories by using the ‘Search’ field
    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-11-21_11-24-04.png

Adding a Recipe to a Course

  1. Select “Add New Recipe” to the course you would like to add it to.

  2. Add a recipe name and the category that this recipe belongs to.

  3. Add your ingredients.

  4. Amend your ‘Cook Time’ and ‘Prep Time’ to the recipe.

  5. Amend your ‘Cost %’ or ‘GP%’ according to what your targets are, you can also amend the ‘Gross Price’ to view alternative costing.

  6. Flag the ingredient to be included in the recipe or not. RB = Recipe Book

  7. Allergens will be displayed if there are any present for that ingredient.

  8. Once you have finished creating your recipe you MUST select ‘Save Changes’

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_09-28-36.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_09-38-24.png

Adding a Temporary Stock Item to a Recipe

A temporary stock item is one that you don’t have the full information for and has not been set up on the database yet, therefore you need to create a temporary stock item that can be used to add to your recipe which will allow you to obtain an accurate costing.

  1. Enter the text of the new item you would like to add.  The system will then decide if the item exists or not, if it doesn’t it will attempt to create a ‘Temporary Stock Item’

  2. Select ‘Yes’ to create the temporary item

  3. Enter the ‘Item Name’

  4. Enter the ‘Stock Size’ – remember to make this a generic size such as ‘KG’ or ‘LT’

  5. Enter the ‘Cost’ of the item i.e. costs £2.50 for a KG of Parsley

  6. Enter the ‘Dispense Size’ name i.e. sprig

  7. Enter the ‘Multiple’ i.e. there are 100 Sprigs in one KG and select ‘Add’

  8. Before you save your changes, you can also add in ‘Allergens’ as well as ‘Suitability’ to the temporary item.

  9. Click on ‘Save Changes’ and then add the temporary item to the recipe including the quantity (Qty) and click on ‘Add’

  10. The Item will have an icon preceding the name indicating it is a temporary item

  11. Save your changes to the recipe

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-04-05.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-08-54.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-16-51.png

Viewing Temporary Stock Items

Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-29-48.png

If you would like to view all your temporary stock items, you will need to navigate away from ‘Menus’ and go into ‘Stock Items’.  Select ‘Temp Stock Items’, this shows you all the temporary items that you have created within all menus.

On the right-hand side “In a Recipe” will show you what temporary items are being used in any recipe.

If you would like to remove any temporary stock items that are not being used in any menu, selecting “Purge unused temporary items” will remove these items from this list.

Recipes List with Temporary Stock Items

Under ‘Recipes’ select ‘Development Recipes’.  This list will show which recipes are using temporary items.

Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-39-06.png

Once all the information has been received from your supplier temporary stock items can be converted into live stock items.  Select a recipe with a temporary stock item, select ‘Convert Temporary Ingredients’ and follow the instructions on screen.

Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_10-57-48.png

Importing an Existing Sales Mix

Here you can add an existing sales mix into a menu, this can be used to give you a more realistic expectation of how the menu will sell.  You cannot import a sales mix for new recipes, but you can edit the sales manually.  Select ‘Import Sales Mix’

  1. Choose the date range you want to import data for and click on ‘OK’

  2. Add your sales quantity for the new recipes under ‘Sales’

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-32-22.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-35-27.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-38-22.png

Viewing Results

  1. The menu allows you to edit the columns you would like to view.

  2. You can compress each course by selecting the downward pointing blue arrow in the course header

  3. You can view your menu results report by selecting on ‘View Menu Report’ or by going into the ‘Reports’ section of the website, Reports – Stock – Stock Definitions – Menu Data

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-42-26.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-47-27.png

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_11-52-53.png

Creating a Recipe Book Page

Once you have created a menu, you will then be able to create a recipe book page.

  1. Select your menu

  2. Select the recipe you would like to create a recipe book page for.

  3. Click on the ‘Notes’ tab

  4. Add your notes under ‘Method’

  5. Select the third tab ‘Final Photo’ and upload your photo, once all done select ‘Save Changes’

  6. To view the Recipe book page you will need to go back into the recipe and select ‘Show Recipe Report’

    Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-13_12-23-46.png

Understanding Your Menu

Macintosh HD:private:var:folders:01:619wpw3n22jgf481f71lg0wr0000gp:T:2016-12-14_08-43-23.png

Suitability:

Suitability for can only be accurate if every ingredient of every recipe has been rated.

If there is one ingredient within a recipe that has not been rated, we will consider that recipe not suitable for any types.